www.gusucode.com > ASP.net 专业开源的OA办公系统源码程序 > ASP.net 专业开源的OA办公系统源码程序\www.gusucodecom\oaPro\gxxz\upload\知识点.txt
调用存储过程 IList<ArticalTypeInfo> lists = BLLGeneric.Select<ArticalTypeInfo>(CommandType.StoredProcedure, "ArticalTypeInfoList"); this.gridArticalInfoList.DataSource = lists; 传参调用存储过程 string loginName = this.txtLoginName.Text; string loginPwd = this.txtLoginPwd.Text; SqlParameter paramLoginName = new SqlParameter("@LoginName",loginName); SqlParameter paramLoginPwd = new SqlParameter("@LoginPwd",loginPwd); IList<UserInfo> lists = UserInfoBLL.Select(CommandType.StoredProcedure, "UserInfoLogin", paramLoginName, paramLoginPwd); 格式化WHERE String bumen=this.ddl_bumen.Text; String where = "em_dept_id='{0}'"; where = string.Format(where,bumen); IList<employee> list = employeeBLL.Select(where);